﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Import_cpdb_Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string strPage = Request["page"];
            int page = 1;
            try
            {
                page = int.Parse(strPage);
                if (page < 1)
                {
                    page = 1;
                }
            }
            catch (Exception ex)
            {
                page = 1;
            }
            bd(page);
        }
        
    }

    public int GetPage()
    {
        return AspNetPager1.CurrentPageIndex;
    }

    private void bd(int page)
    {
        CMSModel.CMSEntities dal = DAL.DBManager.GetCmsEmtity();
        var source = dal.SecuritiesInformation.Where(x=>!x.SecuritiesCode.StartsWith("T"));
        AspNetPager1.RecordCount = source.Count();
        AspNetPager1.CurrentPageIndex = page;
        Repeater1.DataSource = source.OrderByDescending(x => x.SecuritiesCode).Skip((page - 1) * AspNetPager1.PageSize).Take(AspNetPager1.PageSize);
        Repeater1.DataBind();
    }
    protected void btnP_Click(object sender, EventArgs e)
    {
        BLL.StockInfoImport c = new BLL.StockInfoImport();
        c.Import();
    }
}